SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566244 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566244 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942805,411280,465876,511213,730983,247582,681835,657008,398019,586282,19173,682640,12787,218501,314435,395723,464067,341168,846839,503693,251003,406980,735175,490833,932108,580382,710618,342537,142434,759064,589039,581621,605369,184146,793285,243795,1028327,1034991,707470,727927,741993,779159,452927,622847,732205,827571,652236,871875,225321,1047902,868650,51584,567604,113074,614191,68792,625371,682724,668061,573184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]