SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981318 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981318 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356467,237038,284179,442499,880847,97650,190266,497917,411268,34349,766691,57658,347264,128734,957778,29498,908149,498033,175084,269089,30189,890322,914951,1025013,987200,200928,82795,1046751,884292,1033083,749083,102203,678070,113229,816081,623834,334964,105527,665064,533884,321706,145857,923402,241170,36826,336953,418483,97088,540384,971601,388612,789868,410349,826116,702402,493471,591704,688217,867212,751920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]