SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305787 LIMIT 1 [ RunTime:0.001024s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305787 [ RunTime:0.002746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241555,213154,424769,1042514,79444,320706,909645,697381,372604,35382,619397,224413,636807,930578,900405,625176,393950,155628,281691,173590,799897,643008,889212,467202,891165,732290,971731,1039179,600862,387051,268018,880616,527047,449321,419954,299679,72776,292931,196890,885948,1048156,675811,697512,830881,753795,801012,346504,148845,758757,833244,798980,237480,1048709,101584,811819,80701,760352,973378,750283,473696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]