SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342006 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342006 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732337,5407,675150,1322,35232,540224,34871,950606,357285,440927,124168,430237,941679,139970,370528,753455,331882,589418,367881,635664,617081,359982,1024613,868277,367105,625333,84403,248188,494259,748019,791155,519402,661256,344240,86647,542530,1034712,212158,652071,985241,851135,87836,756554,979625,62205,270278,967328,137455,935979,61295,63073,925953,503187,212547,999833,657564,541503,159861,163884,101085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]