SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504249 LIMIT 1 [ RunTime:0.002926s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504249 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611289,421865,412337,646612,812205,337385,768051,338979,526990,65455,105173,202277,529467,531585,438437,309758,551986,693187,583429,574449,385064,1007386,248858,870200,47329,1000750,420337,326956,215376,570174,712873,698539,497288,194352,313955,566783,579513,146117,395020,91192,444197,171354,1038152,478587,740251,80591,334353,995362,905878,125762,21007,479963,878228,301139,389305,336100,709581,219432,277778,794000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004669s ]