SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509571 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509571 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179786,242327,923324,940612,102686,961626,352235,599269,986563,312181,821005,80704,225352,426070,706669,151048,845956,439604,870706,44103,404322,217135,305724,292191,291784,408805,754110,91417,690501,168845,737766,335137,402778,915412,436265,929532,842950,948598,891389,759301,263171,306881,300247,71404,252878,627971,842025,915775,450381,722356,459903,448592,469804,924248,593885,740902,240691,219395,121603,1006321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001746s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]