SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108241 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108241 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524758,928419,278268,567645,513773,269845,386783,78207,36030,947641,126686,141440,718866,78187,857817,142139,392255,843359,548422,41398,134871,442933,66969,241401,358341,486559,1043823,376585,394229,131997,713723,154696,1007549,109425,182649,108604,582300,1010437,453193,757732,1004288,288555,820036,195782,438259,435138,680438,45278,100488,474339,998281,12159,592209,211738,109970,448325,1047644,870933,974252,188451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]