SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49080 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49080 [ RunTime:0.002098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636909,336508,146000,295154,312947,671512,498236,282372,533922,424946,1036203,110501,942954,632561,226440,767345,847740,785973,380518,28387,253043,624995,223465,884617,359363,181273,219375,1041190,740618,458189,351041,244728,770122,1038444,475415,990744,842909,445664,375724,784600,524389,1016285,983658,1008152,696992,723847,614581,710392,873235,413992,417692,146819,682398,330980,500725,262314,291935,715453,651339,502238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]