SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017785 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017785 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748484,27938,351995,921199,986643,65135,836867,469954,1015574,762082,107264,714311,13567,768804,403484,838393,733052,935909,369819,470038,148745,715481,111971,402878,818335,246125,363282,686852,829014,419225,839181,476746,846244,36614,335370,432667,249321,440295,508441,585037,654313,960076,96747,465050,913276,782002,153229,184401,603210,363329,10920,341444,191259,475842,626920,751759,240494,442006,206084,642827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017785 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017785 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]