SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036707 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036707 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345022,357606,331612,412765,571021,508100,187172,494354,124889,734726,369395,919578,637434,352076,856589,555402,71576,729241,625627,251729,585073,784653,58168,576657,534012,65565,89151,523390,31396,203666,178506,562864,20980,378507,205281,47566,327675,937494,19562,687658,821568,331120,372021,1039345,3541,491311,606667,592555,1030723,380042,625540,538468,35072,914994,646649,56208,146150,310770,68927,170287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036707 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036707 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]