SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506816 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506816 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493470,713362,329031,749890,838413,1038291,660749,161166,772189,945549,767950,451149,528157,782807,524488,208603,103051,447103,841237,480659,976076,143340,378442,205461,987240,764879,953910,776988,99262,117692,852106,39663,387731,903716,76941,819739,585718,616050,646932,381925,855949,536067,677011,401577,130224,578433,64292,884665,710247,599262,566153,813304,690029,82179,219025,313583,838156,88229,494815,853275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]