SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509027 LIMIT 1 [ RunTime:0.002480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509027 [ RunTime:0.002777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444311,545375,925408,1006484,473457,767792,422003,215696,243357,65084,64137,455139,394474,454497,599441,177052,627929,194398,130603,737755,905154,106380,148029,332472,434597,202031,914891,237234,224285,751341,431458,953853,907572,939317,858746,131618,1034604,456171,357070,591933,947698,915484,980906,333134,1036116,570168,1009921,1032910,618434,486587,423705,263353,685249,940069,718447,957257,461601,233372,650188,162367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]