SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538323 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538323 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301192,173039,1028422,272628,247951,350512,597313,560790,477972,1048692,849745,144754,945078,309904,1001090,919221,394081,846480,813342,195986,855437,381779,993569,958920,290891,481829,446599,963525,257291,44407,223591,131595,1031746,431182,82629,630836,206120,775424,873485,814081,424946,981353,161210,1007348,703850,573365,595464,477390,540139,672930,671741,716774,717917,335821,230412,922064,335591,949654,863039,651759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]