SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4018 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4018 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124316,212521,777806,467696,608796,957207,1034470,777227,132906,1011017,887826,960491,4966,45368,772643,366230,681849,1041668,781153,617377,113071,709563,90024,998456,875454,474314,290038,549536,489659,81153,315095,917560,220430,736381,16470,128058,1040528,228015,903579,287755,420259,333876,1039137,140341,982573,177177,980427,319653,955656,920499,394063,194581,705059,147645,618529,657921,574341,580457,498947,891869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000923s ]