SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527974 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527974 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943154,12027,1035337,293097,766258,901140,682309,171895,962411,487534,272247,885380,997803,1024433,26685,876987,580261,612460,349713,451323,61317,141380,885071,944543,326144,709635,47063,379329,766587,1022799,253325,1034097,293398,11122,447617,258121,861751,730303,650678,490138,228829,965983,879370,234017,1041198,822870,903132,217692,376852,344012,575598,999995,274250,301506,14469,277279,382182,620229,847736,856794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]