SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017725 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017725 [ RunTime:0.002321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937097,405473,262875,267252,477235,544497,162430,1013576,124292,319974,394957,390170,169972,250399,683513,811193,543974,470330,260932,623402,434523,354280,928617,592871,226712,853798,418310,704340,970849,747104,735613,101417,465225,353391,61900,643009,561981,928400,906157,444473,689233,24094,584588,462036,427776,1044397,31072,856491,125257,544751,296220,403922,206188,76997,189108,398450,800770,1007112,246038,447658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017725 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017725 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]