SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570481 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570481 [ RunTime:0.002381s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600225,955523,60697,340314,745606,541868,82944,243938,205913,798756,315196,912122,699954,780829,409735,527522,757443,781515,923331,743895,823087,422136,618724,1009376,353436,869063,321878,468171,236485,692569,46006,940226,123047,730166,515948,744116,841687,405209,982845,173157,67082,955386,569123,134934,55234,760540,974706,157014,941100,12638,926924,483003,107953,19486,679609,978205,822464,893738,841545,828154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001243s ]