SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401009 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401009 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983202,835429,231044,354019,759172,799708,523884,432777,235424,598240,648903,537961,320461,157840,741769,645600,995364,576861,611920,556644,464121,152378,617128,858083,743844,407266,930512,296195,300906,379445,98964,66382,976826,1037187,1022913,163268,204663,405459,280605,968350,1042209,465878,738813,489895,82244,777275,779609,605815,587926,534030,38232,101508,374388,557915,350877,944857,10741,291589,158067,824130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]