SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517893 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517893 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703522,597590,142083,669774,412710,905534,622603,184528,326939,116849,171032,674503,158104,700787,860464,816123,668393,595759,795537,307492,758176,144913,272000,930721,432976,308156,797795,829777,564649,17563,996393,147110,39231,72226,872782,141815,830950,183140,540540,621005,613631,430401,1011365,173300,452620,106413,357421,195436,314116,20362,57362,97302,771030,736753,306598,536991,961876,784881,911770,749407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]