SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32313 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32313 [ RunTime:0.002133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345907,1010282,339599,749058,484680,318766,127434,219619,538991,132304,584247,732123,175708,573364,393198,368459,101280,1036526,848367,767463,943982,318880,216908,588368,752052,876767,830884,772724,406798,294605,488029,921402,428388,900975,69514,907944,851665,760886,468165,278896,527044,282535,443389,57195,198228,258296,958524,313504,1035025,665481,741525,685182,281057,504811,243450,1021638,960400,864098,273664,1044549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]