SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001980s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335439 LIMIT 1 [ RunTime:0.000959s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335439 [ RunTime:0.005576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940166,752108,810162,991872,507989,699870,930773,249543,454099,423633,35017,923561,555154,432908,42780,945160,552820,197954,441775,750019,1006431,341554,201196,245108,450999,904099,878165,1025200,827274,834799,264784,95291,199022,777353,183523,437513,569526,240682,166143,932034,442308,615832,795919,336692,1034357,1014748,319239,850843,806933,672615,155941,804456,242298,430996,507057,866563,288351,485252,590742,689693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000800s ]