SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254881 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254881 [ RunTime:0.002644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026090,162176,114108,404153,14612,482523,901160,593013,1026617,769427,172566,867589,725027,483097,669736,17039,195702,154978,980977,745477,1002154,332141,63754,439673,40471,108712,888738,356891,99309,366287,625010,207514,436189,986616,469542,785843,490171,420584,837949,627210,292072,771822,300972,573366,278015,26477,864704,868467,599475,824403,34731,960232,1040821,680867,616872,832095,895773,16679,894057,312724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]