SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396314 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396314 [ RunTime:0.002757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019973,147817,835682,70114,1002443,696837,27004,468182,773570,186503,946863,249929,979918,796141,943430,913663,334006,262042,854988,571596,693052,499143,100936,868833,648841,1029993,435193,448236,930866,753969,595893,745722,1022249,948090,405689,224268,479904,1005875,580757,506625,129213,389231,190774,1020841,746519,42183,943704,325724,895747,74552,425211,417127,219726,275960,786137,1028911,942437,489869,655267,197470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001067s ]