SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006185 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006185 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828442,597611,972214,5184,678090,655714,485705,859290,201637,157520,544561,1015567,47690,903499,234445,481788,996425,877280,385576,967894,306985,348564,95543,584163,45741,23220,16855,799579,999866,491480,515840,433142,16801,965667,493025,644156,404055,723589,925400,538058,212318,297339,542154,152307,205528,752366,528194,153594,514335,282509,567449,770400,829701,669279,670677,922258,517069,403496,439756,48400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]