SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422906 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422906 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342518,119470,941622,539956,394027,414574,25929,941204,629780,590937,1040965,189174,92181,738483,978250,608818,635128,139297,357239,150382,633881,579,188398,244236,700927,278280,58474,603307,570356,600232,872061,760757,18272,598920,640225,286343,309867,515740,64900,648341,934123,831676,461128,1031726,575092,721007,523463,903324,523967,500624,909087,437697,877442,483069,583587,426104,929994,141871,79451,515670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]