SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504040 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504040 [ RunTime:0.003320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988229,802856,718624,45098,309756,436721,417112,1010503,928882,862511,824623,934752,479156,147030,37795,188449,803329,902747,230034,786433,667798,244613,344731,452351,609828,675490,144637,925901,300913,90094,114006,96836,767249,659229,151609,952937,876896,223041,722328,665897,789534,786393,656796,338828,559037,88090,508458,372355,520300,834590,423636,972900,782745,600368,211099,192597,394901,243101,277512,960611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003864s ]