SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457944 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457944 [ RunTime:0.001691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728505,170986,977689,3422,770290,672439,714862,168934,312744,166272,378081,437455,48919,221833,916792,197038,625104,349234,161484,906367,701083,143069,6059,905583,693413,970660,80248,192479,591192,1010244,739310,230768,1013112,38572,64068,279338,281468,1046368,391366,345841,17760,70527,238151,771287,1021820,210134,822269,589814,700087,316424,941634,287055,1009115,408331,844044,970986,341706,453804,692252,838727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]