SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031210 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031210 [ RunTime:0.002459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531697,306937,1041103,611924,344064,324073,634821,926976,486104,1022806,625723,581421,424005,628669,1012991,907056,732898,158629,744236,680917,467425,146975,300919,799299,379560,1033868,991664,307214,714165,93913,513075,365065,869681,818457,433262,430768,222754,212140,67521,729518,725178,356670,478278,9849,9926,1048319,525314,558913,241477,94390,454047,888622,555316,472642,216093,551021,691245,897099,102961,835408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]