SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010120 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010120 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593953,657487,882874,778272,140850,780298,283107,209527,881283,553399,707299,708215,1029643,625731,17555,723612,995677,591906,1048801,162989,462083,863463,13451,252341,589459,551518,809528,32466,383764,677341,969190,25789,891022,811209,401213,10562,584820,1032399,111616,792779,480849,364897,310472,123607,303627,181409,775891,156727,479947,53247,71393,579696,70554,561851,502825,883104,305185,650470,787405,522899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]