SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106458 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106458 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402257,677784,245659,494229,954916,257543,280927,297855,82602,330869,353204,570830,651702,670811,619448,132409,474485,369064,311830,287867,901565,502464,831807,366588,300274,647156,366178,1030270,500593,454036,679485,191556,579426,687539,893181,916396,618698,440956,227595,320863,673250,206567,132853,363348,958490,959501,573920,405172,197995,135754,827970,377680,419904,564939,602473,565003,420536,9267,559677,152629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]