SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505738 LIMIT 1 [ RunTime:0.004181s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505738 [ RunTime:0.005244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50748,767888,317965,704915,1026026,970260,916488,388771,436325,1039472,924489,876653,99501,142993,802446,599135,382387,91109,194751,556439,112136,400973,767887,71964,414035,90864,669180,474290,303339,26584,88873,924792,49911,348425,779278,713711,1029087,793650,370257,262334,544920,713019,544603,110388,23954,1040205,536722,291628,83504,304901,511101,95237,204868,33634,425332,289478,441032,235846,305129,1010524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]