SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017160 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017160 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499769,29501,675298,349479,871482,669591,774944,910427,922489,485115,671522,305458,8141,693123,329997,901532,751751,726816,963137,619062,355016,700900,813153,306689,947764,541693,34474,810750,672940,426296,932776,284703,931576,431987,842447,966936,520783,312280,96930,66575,692061,218965,710490,868867,598744,253531,73153,528064,467265,986322,553947,65711,598189,225924,250710,737008,943646,268876,735194,759969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]