SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514512 LIMIT 1 [ RunTime:0.001271s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514512 [ RunTime:0.003100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899306,719839,326668,1031030,960107,592605,882708,659324,899774,991635,808551,714377,127459,127986,731751,34672,151668,1036880,713507,938193,707841,340549,104200,332831,76375,89819,553555,702470,1022406,953053,131930,669458,254740,410832,491379,511329,30133,125055,777017,554500,56375,438562,881764,520333,613124,86469,1019403,101598,182118,102680,955064,520650,700423,371273,313375,375808,346512,96974,383744,1037313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]