SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559093 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559093 [ RunTime:0.002606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705626,122073,720934,179690,462206,505357,322418,523033,957373,248717,750437,50135,133977,257907,635024,82675,741741,330316,568636,81319,725237,844087,188369,691320,136883,236513,84608,979188,189079,147594,422721,906465,455033,243858,80983,391105,998290,490001,856975,216388,676304,17016,348634,1033332,89598,446091,839165,388571,351711,208199,164545,197084,453545,328330,784872,1004035,221604,947530,17818,569382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]