SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556511 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556511 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157882,94297,669879,906955,112694,178554,354190,42885,207790,75135,56866,1207,978618,1021092,253606,187545,673285,117396,1006636,988599,997413,182322,1011946,797126,869657,469324,347623,668256,369249,445148,771169,579425,978225,751283,19456,647456,824271,567662,298200,827155,549198,923590,813520,753336,241754,205480,311765,941451,97073,3987,876475,1035147,815561,510638,1033061,405606,469492,368416,870597,583030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]