SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199888 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199888 [ RunTime:0.002457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473822,229832,573697,866852,82195,510832,910142,250224,656359,872190,1007273,722320,573478,660596,385482,710382,817119,652517,658673,532009,544252,118424,892045,763393,323312,629125,59819,150230,577739,261196,359290,736699,82486,652865,731118,808309,284556,104736,1005272,867137,169258,24818,739091,735001,854701,150571,466764,668518,457875,681393,79227,395617,1030034,342462,835958,362505,448365,41996,135353,655387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003045s ]