SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106991 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106991 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256536,443955,596909,434939,597143,92860,480896,370065,317931,79297,208442,583728,879396,981629,332586,325695,136832,613294,98056,631487,441961,308330,806945,487342,112530,918205,5515,438625,684007,612793,1005140,636363,846384,686609,221721,431926,793331,757139,514711,890205,235701,180927,350462,796092,936878,795244,419846,399397,912892,282016,858885,432748,618107,596177,64879,707005,642010,220559,894288,456159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]