SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559097 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559097 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689820,1009356,671652,567923,243090,80826,219103,486101,255336,898223,251842,409603,689131,73272,933438,563437,828835,607431,850136,45143,791169,212702,557858,980420,603369,724485,894502,342616,374896,236979,335798,389290,82770,448420,631142,37546,1033481,376678,74837,568234,935742,1040983,463788,983643,820936,272392,410078,278041,1038123,74015,377614,539172,376828,199561,55016,113073,490318,306028,161620,130936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004899s ]