SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387511 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387511 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481819,680038,171023,546527,814355,699451,884251,681599,1035575,87463,854844,241841,498886,983350,20626,720934,299942,760764,437865,558738,215138,156699,245400,898190,60332,789686,970640,586223,274800,65809,645928,176424,824914,370399,737403,600455,208696,1013560,523888,380245,354950,23883,448601,401018,310243,389400,905505,731219,173341,55838,1000546,406192,747358,204815,937102,96012,254016,26167,874997,824155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]