SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420410 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420410 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57646,691651,716612,840264,643145,892349,469633,515480,785696,300595,778002,986928,468484,568563,961636,550295,105807,480333,880149,30227,775370,700020,1008690,319833,88678,393993,911692,244294,2317,37174,860862,772297,982546,41358,692159,956499,840309,266044,441914,926474,85300,186785,556607,933148,307612,782725,378793,49950,898376,422620,555329,360436,850937,149814,737018,794354,325070,54251,231645,948897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]