SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498708 LIMIT 1 [ RunTime:0.001062s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498708 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284471,1040597,861646,844628,227437,29815,364669,20414,227784,773528,469873,371703,831312,236702,625864,805063,279222,525592,189974,475072,1024608,635195,83510,292550,434817,646858,665340,84875,251257,567653,341208,803908,775850,253764,547999,742577,396923,315006,614513,357714,371875,298464,585611,813015,350674,613692,747834,203762,808022,108957,329259,17423,733792,74354,707651,93957,117932,642760,1010553,104007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]