SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017291 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017291 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794217,906757,584013,286178,912818,685510,421689,672637,82176,247976,779451,828304,458922,235475,187222,633281,625603,221304,127418,127859,608812,172258,478563,833814,664007,849880,606190,600325,881373,664863,513149,829140,386470,374847,647983,87729,321156,139406,976512,399738,437613,170153,318893,307585,177946,549821,546651,932947,17780,184922,317140,169891,165124,706838,566619,898127,370782,718898,548044,872109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000826s ]