SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520420 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520420 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706506,657161,544482,35522,1018788,277088,540254,1044876,54439,516989,35478,520890,680782,965412,136757,289260,594296,390300,626546,840174,708400,838925,343882,144979,59,539692,615176,464261,389475,747895,602083,799159,850390,803456,901250,961138,29310,51630,487311,2943,652695,218394,725364,293543,262218,706137,762491,54333,584869,699740,502771,645097,948385,765728,157325,820815,289784,650646,91584,453499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]