SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320575 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320575 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639067,861731,333621,780517,553392,20581,698361,481824,614200,1010505,682418,500796,377542,122642,678654,26814,490297,933240,185346,226592,987959,1032455,906267,635387,798066,807613,1036590,127237,720994,992436,205294,307500,896606,422350,1011062,199085,842730,909632,993419,905444,442365,840276,592904,731485,229331,758201,294663,806002,820743,161576,457184,384398,495709,933443,541198,379384,312490,899427,301919,499664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]