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` = 101061 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101061 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716865,598989,881824,855021,413217,936439,34638,536498,732392,189772,542909,7506,204422,318138,1014037,946153,573019,685591,132262,983335,624120,9873,18607,441297,1027840,812458,515727,621996,893744,988589,266700,703887,916961,904394,698173,813349,141326,224233,645240,718178,569467,486305,195018,49197,657074,78089,930970,228581,97796,283504,385946,994658,1012366,732605,264946,383189,159374,766335,728362,592928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]