SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198653 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198653 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737992,922064,646962,113543,678445,200774,1018287,949125,329923,508603,929186,714947,257811,198024,910297,715371,406961,906389,795994,779265,181780,499706,135306,4103,631181,255647,247193,106313,736449,611423,301100,370076,131236,221440,314183,901947,670462,879580,899174,61969,488344,626376,942510,835812,90158,667510,965376,379261,63201,939441,308916,93544,156443,681910,565767,516708,374752,1022417,1031777,27991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]