SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502902 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502902 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042731,471255,839184,723993,856652,15221,702513,491859,681529,379731,792143,599599,716170,478037,758193,61457,544451,677491,549866,199319,138204,349641,1031115,782441,319399,84920,519745,636628,81069,488588,584859,138205,405534,651679,295262,438549,747429,728229,55248,5940,781148,324090,796693,328747,633145,425376,708308,296128,766795,1007142,548583,548574,790658,428022,123683,328543,722063,446190,707816,303059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]