SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509991 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509991 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565371,1039080,941569,777131,25382,411586,509047,680838,584302,27959,636911,455100,994051,1014797,762439,846794,497954,65880,697894,612490,938476,217485,32299,828236,774732,121802,557593,956367,896059,240074,989344,1040889,481260,881790,921401,150734,950303,235495,82355,152204,972372,294664,249249,310527,109214,192292,263899,373211,384493,8535,892031,441012,171674,455972,815899,352292,210753,944489,444552,828204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]