SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409331 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409331 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4337,75478,145022,409534,215896,977608,799572,562075,830009,1039470,412671,910177,933792,601554,2062,302613,748616,868814,1010307,247859,276372,725750,218172,744752,934187,407573,74680,286307,960543,250688,289203,115591,186977,31613,373804,88545,1021262,248793,546069,240841,817838,1016423,542492,323602,52102,314949,765513,1007431,941110,606889,112945,335595,368307,763467,70935,640462,297974,1916,110198,761571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]