SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044121 LIMIT 1 [ RunTime:0.000750s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044121 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816743,678377,799869,856690,238724,210510,378415,221872,34017,372259,813509,553849,890294,44131,93033,188292,73524,706315,341323,976028,729656,919739,796255,718689,141025,112725,782865,59776,1038843,363581,745644,929184,864336,767328,605976,429329,805117,806944,882637,747667,167443,777061,645633,4834,249383,631795,655816,260725,927937,1020717,954893,820156,39038,432361,121587,800545,448819,326070,623502,140946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]