SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505714 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505714 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662436,1041826,666300,672156,1014032,923006,207647,806004,662755,151723,785513,900897,424735,117331,516231,860704,1025101,327295,417123,552523,762008,768647,717138,841044,749025,573252,597553,439349,3582,508704,330420,1036170,649617,244335,941143,1038538,905246,400967,516549,289158,220828,11574,338524,180653,705212,343622,583980,523658,388178,774865,320950,977926,822157,797070,433048,131587,1014180,465855,617049,125691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]