SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804364 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804364 [ RunTime:0.008391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469645,483934,625767,68658,214813,1017504,229733,113585,95343,748171,392350,698175,851489,112127,134575,413131,402247,1025682,763975,524925,898341,604648,7593,954392,225295,194210,1028141,1007949,341336,460773,320266,352976,53303,100621,261280,956738,279779,880038,403657,360342,162884,365961,419188,621580,542104,199890,296941,440971,606738,399102,901092,591567,224572,855342,83941,212298,799305,157782,903664,318600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]