SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405823 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405823 [ RunTime:0.006259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633778,1011115,81133,1018540,653048,695600,887693,549691,652693,938908,78667,752906,10953,664399,988626,518703,587148,528561,186050,737132,711791,539576,22559,274245,303330,674463,260820,702416,146828,517646,39014,484539,538176,102866,218159,785640,226586,350602,470936,962110,588058,751168,969154,990404,570101,113338,404125,310534,9448,802597,906060,278804,575820,102308,279419,401093,720085,980795,449677,643610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]