SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565217 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565217 [ RunTime:0.001495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15136,531241,131034,947803,943844,44166,940517,371070,590261,235633,239010,562918,616613,1004362,371847,436185,741371,703303,578846,545082,772660,70412,35715,951082,2625,863809,243159,771036,295343,986605,407081,317501,80841,851493,284189,999283,913610,527770,23034,875092,963192,127785,30246,1014430,272621,512732,1021404,739865,568710,431465,914182,639746,252934,994923,691980,442382,584156,759664,709357,199217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004611s ]