SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 723516 LIMIT 1 [ RunTime:0.000627s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 723516 [ RunTime:0.002878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298129,337216,248268,174464,263611,47639,554631,394601,552433,596345,812772,935367,448348,117405,919290,226346,714901,1025043,517261,953780,30099,296762,405595,782726,534274,740696,117866,464670,898352,803829,867552,165275,165429,288111,1018808,274668,655406,243114,180001,306945,696256,664134,212778,97314,938682,262302,841558,741268,47866,507447,692347,176758,772473,840807,573207,200957,97577,224642,261139,466931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 723516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 723516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001623s ]