SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593674 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593674 [ RunTime:0.008068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640402,555081,713087,386776,928220,649937,972355,109514,211697,287907,402928,1000151,895263,175016,711417,419524,815425,918096,1028242,527266,649018,295178,1012531,389290,1047238,311869,259828,159420,560205,1014491,749244,405106,961150,919178,81641,299147,711080,56545,136009,585666,986948,276615,219242,47276,277100,197436,285398,212424,512021,224740,704673,664623,889051,741777,59528,463225,346336,1037199,879033,215375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001815s ]