SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 358458 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 358458 [ RunTime:0.004404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60046,712633,251870,164934,40971,480746,295309,43904,1019612,674077,951341,185004,662387,707423,616869,459748,873448,993960,997993,283840,520725,898581,754551,804764,630295,262598,250992,683741,663111,144798,777312,438813,210796,965282,854657,933209,406365,933218,940188,204565,881140,328727,468120,275225,828500,759506,806666,152758,387974,861194,260049,461202,47764,206176,619748,24112,513430,1047440,399173,379506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 358458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 358458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]