SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554411 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554411 [ RunTime:0.002910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204326,138696,216550,813680,28857,751815,3182,746644,394789,462627,1036857,23203,680778,107263,405071,34077,797900,101480,369166,378243,507374,727102,677831,373293,158186,315371,211052,140482,575305,150294,919320,302232,452799,659543,594644,183005,315095,270921,346144,63066,897773,495697,499800,1012873,874777,137602,932480,1033340,821982,828083,701244,163002,409117,292131,953397,957938,522752,768331,555111,219920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001108s ]