SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010603 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010603 [ RunTime:0.003911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3206,681725,869360,639737,528822,555357,57729,707525,1016137,884103,894976,621671,946248,874306,92510,702892,764112,525129,910902,271069,781783,322774,610344,466933,79054,386335,591598,970919,55161,1041811,516051,971365,201718,351821,837928,971179,817213,414414,1019676,40639,789331,792955,190797,869713,564724,207550,1009271,282269,948622,852651,271000,97783,936538,181343,800477,377209,794657,878594,805923,350409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001407s ]