SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504826 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504826 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855053,634178,946749,316890,1022680,1040841,442318,530482,481437,158112,693484,464154,847256,912262,592530,439262,205388,348051,351033,282744,711452,925951,934780,152598,126625,232902,34492,1000913,987623,615387,43827,700058,911759,504470,382087,370437,762464,993594,191695,400216,732343,683698,80825,453949,990375,390087,275518,20376,198514,837359,403251,483106,739800,695354,785482,778223,936040,354700,233221,296487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000962s ]