SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340710 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340710 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108153,646520,62532,60192,892661,555753,877041,875980,187685,875906,894931,1031906,688021,249019,443409,247702,655897,408615,83354,100773,1016812,1044480,604204,199045,833943,272934,347259,555433,998327,238301,934437,413130,885760,855860,434631,315529,984962,876546,1026887,214529,764775,452394,596469,848643,622644,943881,548364,497022,446779,823270,159408,812213,513196,49243,183348,434819,48703,529959,731134,95404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004652s ]