SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528414 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528414 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340549,13540,572822,418188,445694,853166,288548,835465,327838,52065,937713,149111,952670,210312,973375,192810,858296,200735,249144,376932,948071,305539,1017383,1007255,399388,278313,595077,78228,385217,729977,1001972,126304,393851,168810,690180,640719,638479,484022,248167,192518,434292,30112,182499,827097,552357,523200,67606,411409,324355,578131,838598,949778,640751,158769,289297,726997,296800,835606,295239,714152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]