SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 733480 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 733480 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004879,889020,734289,408198,906133,515790,939574,75636,958635,847658,486866,819101,1011255,962284,538501,329927,954493,437963,26927,299114,1045205,734946,140787,602198,268963,1039397,35119,551219,32348,454822,34858,494323,804585,71191,501967,354027,317101,449909,952405,424784,1020191,324705,88200,8907,219678,902600,503905,227907,802613,294792,950274,420750,752072,451499,837295,90263,785383,1027728,28729,915715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 733480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 733480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]