SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291893 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291893 [ RunTime:0.004361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68047,444597,701803,963706,757384,205352,981942,792126,571268,944908,110956,349309,344239,733356,338582,460377,944720,204326,580494,991549,550930,735803,839109,984080,878240,873553,1035659,329503,503078,576956,814485,246063,957597,379994,366919,554256,477264,306850,688097,1031961,456835,525112,725728,419948,615406,753645,652071,515675,74380,637796,395571,844737,601484,414170,698783,375940,76320,795271,17427,818683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004191s ]