SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567951 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567951 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92258,722528,656710,496421,779771,883765,105131,1007355,90519,879092,1046151,590687,763798,314652,605100,769841,887358,355879,760054,186185,1002196,614561,606594,322064,863533,1027657,920682,407562,183840,973706,509080,709673,690388,713863,773419,152026,400530,533388,593095,104941,443821,23655,384590,937583,914888,199911,1020567,712505,141342,797543,290096,170150,249047,269390,757502,112424,1046775,1044762,832567,447725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]